﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="GPPNhaThuocDataSet" targetNamespace="http://tempuri.org/GPPNhaThuocDataSet.xsd" xmlns:mstns="http://tempuri.org/GPPNhaThuocDataSet.xsd" xmlns="http://tempuri.org/GPPNhaThuocDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="GPPNhaThuocConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GPPNhaThuocConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.NhaThuoc.My.MySettings.GlobalReference.Default.GPPNhaThuocConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChaTableAdapter" GeneratorDataComponentClassName="ChaTableAdapter" Name="Cha" UserDataComponentName="ChaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GPPNhaThuocConnectionString (MySettings)" DbObjectName="GPPNhaThuoc.dbo.Cha" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cha] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_nhacungcap = 1 AND [nhacungcap] IS NULL) OR ([nhacungcap] = @Original_nhacungcap)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhacungcap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhacungcap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhacungcap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhacungcap" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cha] ([ma], [ten], [nhacungcap]) VALUES (@ma, @ten, @nhacungcap);
SELECT ma, ten, nhacungcap FROM Cha WHERE (ma = @ma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhacungcap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhacungcap" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, nhacungcap FROM dbo.Cha</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cha] SET [ma] = @ma, [ten] = @ten, [nhacungcap] = @nhacungcap WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_nhacungcap = 1 AND [nhacungcap] IS NULL) OR ([nhacungcap] = @Original_nhacungcap)));
SELECT ma, ten, nhacungcap FROM Cha WHERE (ma = @ma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhacungcap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhacungcap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhacungcap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhacungcap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhacungcap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhacungcap" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="nhacungcap" DataSetColumn="nhacungcap" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMDoiTuongTableAdapter" GeneratorDataComponentClassName="DMDoiTuongTableAdapter" Name="DMDoiTuong" UserDataComponentName="DMDoiTuongTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GPPNhaThuocConnectionString (MySettings)" DbObjectName="GPPNhaThuoc.dbo.DMDoiTuong" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMDoiTuong] WHERE (([id] = @Original_id) AND ([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMDoiTuong] ([id], [ma], [ten], [diachi], [dienthoai], [masothue], [fax], [email], [ghichu], [chinhanh], [tinhtrang]) VALUES (@id, @ma, @ten, @diachi, @dienthoai, @masothue, @fax, @email, @ghichu, @chinhanh, @tinhtrang);
SELECT id, ma, ten, diachi, dienthoai, masothue, fax, email, ghichu, chinhanh, tinhtrang FROM DMDoiTuong WHERE (ma = @ma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, ma, ten, diachi, dienthoai, masothue, fax, email, ghichu, chinhanh, tinhtrang FROM dbo.DMDoiTuong</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMDoiTuong] SET [id] = @id, [ma] = @ma, [ten] = @ten, [diachi] = @diachi, [dienthoai] = @dienthoai, [masothue] = @masothue, [fax] = @fax, [email] = @email, [ghichu] = @ghichu, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang WHERE (([id] = @Original_id) AND ([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)));
SELECT id, ma, ten, diachi, dienthoai, masothue, fax, email, ghichu, chinhanh, tinhtrang FROM DMDoiTuong WHERE (ma = @ma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConTableAdapter" GeneratorDataComponentClassName="ConTableAdapter" Name="Con" UserDataComponentName="ConTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GPPNhaThuocConnectionString (MySettings)" DbObjectName="GPPNhaThuoc.dbo.Con" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Con] WHERE (([ma] = @Original_ma) AND ((@IsNull_mahanghoa = 1 AND [mahanghoa] IS NULL) OR ([mahanghoa] = @Original_mahanghoa)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_soluong = 1 AND [soluong] IS NULL) OR ([soluong] = @Original_soluong)) AND ((@IsNull_dongia = 1 AND [dongia] IS NULL) OR ([dongia] = @Original_dongia)) AND ((@IsNull_thanhtien = 1 AND [thanhtien] IS NULL) OR ([thanhtien] = @Original_thanhtien)) AND ((@IsNull_solo = 1 AND [solo] IS NULL) OR ([solo] = @Original_solo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_solo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Con] ([ma], [mahanghoa], [ten], [ghichu], [soluong], [dongia], [thanhtien], [solo]) VALUES (@ma, @mahanghoa, @ten, @ghichu, @soluong, @dongia, @thanhtien, @solo);
SELECT ma, mahanghoa, ten, ghichu, soluong, dongia, thanhtien, solo FROM Con WHERE (ma = @ma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, mahanghoa, ten, ghichu, soluong, dongia, thanhtien, solo FROM dbo.Con</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Con] SET [ma] = @ma, [mahanghoa] = @mahanghoa, [ten] = @ten, [ghichu] = @ghichu, [soluong] = @soluong, [dongia] = @dongia, [thanhtien] = @thanhtien, [solo] = @solo WHERE (([ma] = @Original_ma) AND ((@IsNull_mahanghoa = 1 AND [mahanghoa] IS NULL) OR ([mahanghoa] = @Original_mahanghoa)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_soluong = 1 AND [soluong] IS NULL) OR ([soluong] = @Original_soluong)) AND ((@IsNull_dongia = 1 AND [dongia] IS NULL) OR ([dongia] = @Original_dongia)) AND ((@IsNull_thanhtien = 1 AND [thanhtien] IS NULL) OR ([thanhtien] = @Original_thanhtien)) AND ((@IsNull_solo = 1 AND [solo] IS NULL) OR ([solo] = @Original_solo)));
SELECT ma, mahanghoa, ten, ghichu, soluong, dongia, thanhtien, solo FROM Con WHERE (ma = @ma)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_solo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_solo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="solo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="mahanghoa" DataSetColumn="mahanghoa" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="soluong" DataSetColumn="soluong" />
              <Mapping SourceColumn="dongia" DataSetColumn="dongia" />
              <Mapping SourceColumn="thanhtien" DataSetColumn="thanhtien" />
              <Mapping SourceColumn="solo" DataSetColumn="solo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DMHangHoaTableAdapter" GeneratorDataComponentClassName="DMHangHoaTableAdapter" Name="DMHangHoa" UserDataComponentName="DMHangHoaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GPPNhaThuocConnectionString (MySettings)" DbObjectName="GPPNhaThuoc.dbo.DMHangHoa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DMHangHoa] WHERE (([id] = @Original_id) AND ((@IsNull_mahanghoa = 1 AND [mahanghoa] IS NULL) OR ([mahanghoa] = @Original_mahanghoa)) AND ((@IsNull_tenhanghoa = 1 AND [tenhanghoa] IS NULL) OR ([tenhanghoa] = @Original_tenhanghoa)) AND ((@IsNull_manhom = 1 AND [manhom] IS NULL) OR ([manhom] = @Original_manhom)) AND ((@IsNull_loaihh = 1 AND [loaihh] IS NULL) OR ([loaihh] = @Original_loaihh)) AND ((@IsNull_thuevat = 1 AND [thuevat] IS NULL) OR ([thuevat] = @Original_thuevat)) AND ((@IsNull_madvt = 1 AND [madvt] IS NULL) OR ([madvt] = @Original_madvt)) AND ((@IsNull_donvitinh = 1 AND [donvitinh] IS NULL) OR ([donvitinh] = @Original_donvitinh)) AND ((@IsNull_quicach = 1 AND [quicach] IS NULL) OR ([quicach] = @Original_quicach)) AND ((@IsNull_tonkhotoithieu = 1 AND [tonkhotoithieu] IS NULL) OR ([tonkhotoithieu] = @Original_tonkhotoithieu)) AND ((@IsNull_tonkhotoida = 1 AND [tonkhotoida] IS NULL) OR ([tonkhotoida] = @Original_tonkhotoida)) AND ((@IsNull_canhbaohandung = 1 AND [canhbaohandung] IS NULL) OR ([canhbaohandung] = @Original_canhbaohandung)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manhom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manhom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thuevat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madvt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madvt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madvt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quicach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoithieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_canhbaohandung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="canhbaohandung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_canhbaohandung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="canhbaohandung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DMHangHoa] ([id], [mahanghoa], [tenhanghoa], [manhom], [loaihh], [thuevat], [madvt], [donvitinh], [quicach], [tonkhotoithieu], [tonkhotoida], [canhbaohandung], [chinhanh], [tinhtrang]) VALUES (@id, @mahanghoa, @tenhanghoa, @manhom, @loaihh, @thuevat, @madvt, @donvitinh, @quicach, @tonkhotoithieu, @tonkhotoida, @canhbaohandung, @chinhanh, @tinhtrang);
SELECT id, mahanghoa, tenhanghoa, manhom, loaihh, thuevat, madvt, donvitinh, quicach, tonkhotoithieu, tonkhotoida, canhbaohandung, chinhanh, tinhtrang FROM DMHangHoa WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madvt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@canhbaohandung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="canhbaohandung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, mahanghoa, tenhanghoa, manhom, loaihh, thuevat, madvt, donvitinh, quicach, tonkhotoithieu, tonkhotoida, canhbaohandung, chinhanh, tinhtrang FROM dbo.DMHangHoa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DMHangHoa] SET [id] = @id, [mahanghoa] = @mahanghoa, [tenhanghoa] = @tenhanghoa, [manhom] = @manhom, [loaihh] = @loaihh, [thuevat] = @thuevat, [madvt] = @madvt, [donvitinh] = @donvitinh, [quicach] = @quicach, [tonkhotoithieu] = @tonkhotoithieu, [tonkhotoida] = @tonkhotoida, [canhbaohandung] = @canhbaohandung, [chinhanh] = @chinhanh, [tinhtrang] = @tinhtrang WHERE (([id] = @Original_id) AND ((@IsNull_mahanghoa = 1 AND [mahanghoa] IS NULL) OR ([mahanghoa] = @Original_mahanghoa)) AND ((@IsNull_tenhanghoa = 1 AND [tenhanghoa] IS NULL) OR ([tenhanghoa] = @Original_tenhanghoa)) AND ((@IsNull_manhom = 1 AND [manhom] IS NULL) OR ([manhom] = @Original_manhom)) AND ((@IsNull_loaihh = 1 AND [loaihh] IS NULL) OR ([loaihh] = @Original_loaihh)) AND ((@IsNull_thuevat = 1 AND [thuevat] IS NULL) OR ([thuevat] = @Original_thuevat)) AND ((@IsNull_madvt = 1 AND [madvt] IS NULL) OR ([madvt] = @Original_madvt)) AND ((@IsNull_donvitinh = 1 AND [donvitinh] IS NULL) OR ([donvitinh] = @Original_donvitinh)) AND ((@IsNull_quicach = 1 AND [quicach] IS NULL) OR ([quicach] = @Original_quicach)) AND ((@IsNull_tonkhotoithieu = 1 AND [tonkhotoithieu] IS NULL) OR ([tonkhotoithieu] = @Original_tonkhotoithieu)) AND ((@IsNull_tonkhotoida = 1 AND [tonkhotoida] IS NULL) OR ([tonkhotoida] = @Original_tonkhotoida)) AND ((@IsNull_canhbaohandung = 1 AND [canhbaohandung] IS NULL) OR ([canhbaohandung] = @Original_canhbaohandung)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ((@IsNull_tinhtrang = 1 AND [tinhtrang] IS NULL) OR ([tinhtrang] = @Original_tinhtrang)));
SELECT id, mahanghoa, tenhanghoa, manhom, loaihh, thuevat, madvt, donvitinh, quicach, tonkhotoithieu, tonkhotoida, canhbaohandung, chinhanh, tinhtrang FROM DMHangHoa WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@manhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaihh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@madvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madvt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@canhbaohandung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="canhbaohandung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mahanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mahanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mahanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenhanghoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenhanghoa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenhanghoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_manhom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="manhom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_manhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="manhom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaihh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaihh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaihh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaihh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thuevat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thuevat" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thuevat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_madvt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="madvt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_madvt" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="madvt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_donvitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_donvitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="donvitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quicach" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quicach" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quicach" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoithieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoithieu" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoithieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tonkhotoida" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tonkhotoida" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tonkhotoida" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_canhbaohandung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="canhbaohandung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_canhbaohandung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="canhbaohandung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tinhtrang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tinhtrang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tinhtrang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="mahanghoa" DataSetColumn="mahanghoa" />
              <Mapping SourceColumn="tenhanghoa" DataSetColumn="tenhanghoa" />
              <Mapping SourceColumn="manhom" DataSetColumn="manhom" />
              <Mapping SourceColumn="loaihh" DataSetColumn="loaihh" />
              <Mapping SourceColumn="thuevat" DataSetColumn="thuevat" />
              <Mapping SourceColumn="madvt" DataSetColumn="madvt" />
              <Mapping SourceColumn="donvitinh" DataSetColumn="donvitinh" />
              <Mapping SourceColumn="quicach" DataSetColumn="quicach" />
              <Mapping SourceColumn="tonkhotoithieu" DataSetColumn="tonkhotoithieu" />
              <Mapping SourceColumn="tonkhotoida" DataSetColumn="tonkhotoida" />
              <Mapping SourceColumn="canhbaohandung" DataSetColumn="canhbaohandung" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="tinhtrang" DataSetColumn="tinhtrang" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="GPPNhaThuocDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GPPNhaThuocDataSet" msprop:Generator_UserDSName="GPPNhaThuocDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cha" msprop:Generator_TableClassName="ChaDataTable" msprop:Generator_TableVarName="tableCha" msprop:Generator_TablePropName="Cha" msprop:Generator_RowDeletingName="ChaRowDeleting" msprop:Generator_RowChangingName="ChaRowChanging" msprop:Generator_RowEvHandlerName="ChaRowChangeEventHandler" msprop:Generator_RowDeletedName="ChaRowDeleted" msprop:Generator_UserTableName="Cha" msprop:Generator_RowChangedName="ChaRowChanged" msprop:Generator_RowEvArgName="ChaRowChangeEvent" msprop:Generator_RowClassName="ChaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nhacungcap" msprop:Generator_ColumnVarNameInTable="columnnhacungcap" msprop:Generator_ColumnPropNameInRow="nhacungcap" msprop:Generator_ColumnPropNameInTable="nhacungcapColumn" msprop:Generator_UserColumnName="nhacungcap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMDoiTuong" msprop:Generator_TableClassName="DMDoiTuongDataTable" msprop:Generator_TableVarName="tableDMDoiTuong" msprop:Generator_TablePropName="DMDoiTuong" msprop:Generator_RowDeletingName="DMDoiTuongRowDeleting" msprop:Generator_RowChangingName="DMDoiTuongRowChanging" msprop:Generator_RowEvHandlerName="DMDoiTuongRowChangeEventHandler" msprop:Generator_RowDeletedName="DMDoiTuongRowDeleted" msprop:Generator_UserTableName="DMDoiTuong" msprop:Generator_RowChangedName="DMDoiTuongRowChanged" msprop:Generator_RowEvArgName="DMDoiTuongRowChangeEvent" msprop:Generator_RowClassName="DMDoiTuongRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Con" msprop:Generator_TableClassName="ConDataTable" msprop:Generator_TableVarName="tableCon" msprop:Generator_TablePropName="Con" msprop:Generator_RowDeletingName="ConRowDeleting" msprop:Generator_RowChangingName="ConRowChanging" msprop:Generator_RowEvHandlerName="ConRowChangeEventHandler" msprop:Generator_RowDeletedName="ConRowDeleted" msprop:Generator_UserTableName="Con" msprop:Generator_RowChangedName="ConRowChanged" msprop:Generator_RowEvArgName="ConRowChangeEvent" msprop:Generator_RowClassName="ConRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mahanghoa" msprop:Generator_ColumnVarNameInTable="columnmahanghoa" msprop:Generator_ColumnPropNameInRow="mahanghoa" msprop:Generator_ColumnPropNameInTable="mahanghoaColumn" msprop:Generator_UserColumnName="mahanghoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soluong" msprop:Generator_ColumnVarNameInTable="columnsoluong" msprop:Generator_ColumnPropNameInRow="soluong" msprop:Generator_ColumnPropNameInTable="soluongColumn" msprop:Generator_UserColumnName="soluong" type="xs:decimal" minOccurs="0" />
              <xs:element name="dongia" msprop:Generator_ColumnVarNameInTable="columndongia" msprop:Generator_ColumnPropNameInRow="dongia" msprop:Generator_ColumnPropNameInTable="dongiaColumn" msprop:Generator_UserColumnName="dongia" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtien" msprop:Generator_ColumnVarNameInTable="columnthanhtien" msprop:Generator_ColumnPropNameInRow="thanhtien" msprop:Generator_ColumnPropNameInTable="thanhtienColumn" msprop:Generator_UserColumnName="thanhtien" type="xs:decimal" minOccurs="0" />
              <xs:element name="solo" msprop:Generator_ColumnVarNameInTable="columnsolo" msprop:Generator_ColumnPropNameInRow="solo" msprop:Generator_ColumnPropNameInTable="soloColumn" msprop:Generator_UserColumnName="solo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DMHangHoa" msprop:Generator_TableClassName="DMHangHoaDataTable" msprop:Generator_TableVarName="tableDMHangHoa" msprop:Generator_TablePropName="DMHangHoa" msprop:Generator_RowDeletingName="DMHangHoaRowDeleting" msprop:Generator_RowChangingName="DMHangHoaRowChanging" msprop:Generator_RowEvHandlerName="DMHangHoaRowChangeEventHandler" msprop:Generator_RowDeletedName="DMHangHoaRowDeleted" msprop:Generator_UserTableName="DMHangHoa" msprop:Generator_RowChangedName="DMHangHoaRowChanged" msprop:Generator_RowEvArgName="DMHangHoaRowChangeEvent" msprop:Generator_RowClassName="DMHangHoaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
              <xs:element name="mahanghoa" msprop:Generator_ColumnVarNameInTable="columnmahanghoa" msprop:Generator_ColumnPropNameInRow="mahanghoa" msprop:Generator_ColumnPropNameInTable="mahanghoaColumn" msprop:Generator_UserColumnName="mahanghoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenhanghoa" msprop:Generator_ColumnVarNameInTable="columntenhanghoa" msprop:Generator_ColumnPropNameInRow="tenhanghoa" msprop:Generator_ColumnPropNameInTable="tenhanghoaColumn" msprop:Generator_UserColumnName="tenhanghoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="manhom" msprop:Generator_ColumnVarNameInTable="columnmanhom" msprop:Generator_ColumnPropNameInRow="manhom" msprop:Generator_ColumnPropNameInTable="manhomColumn" msprop:Generator_UserColumnName="manhom" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaihh" msprop:Generator_ColumnVarNameInTable="columnloaihh" msprop:Generator_ColumnPropNameInRow="loaihh" msprop:Generator_ColumnPropNameInTable="loaihhColumn" msprop:Generator_UserColumnName="loaihh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thuevat" msprop:Generator_ColumnVarNameInTable="columnthuevat" msprop:Generator_ColumnPropNameInRow="thuevat" msprop:Generator_ColumnPropNameInTable="thuevatColumn" msprop:Generator_UserColumnName="thuevat" type="xs:decimal" minOccurs="0" />
              <xs:element name="madvt" msprop:Generator_ColumnVarNameInTable="columnmadvt" msprop:Generator_ColumnPropNameInRow="madvt" msprop:Generator_ColumnPropNameInTable="madvtColumn" msprop:Generator_UserColumnName="madvt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="donvitinh" msprop:Generator_ColumnVarNameInTable="columndonvitinh" msprop:Generator_ColumnPropNameInRow="donvitinh" msprop:Generator_ColumnPropNameInTable="donvitinhColumn" msprop:Generator_UserColumnName="donvitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quicach" msprop:Generator_ColumnVarNameInTable="columnquicach" msprop:Generator_ColumnPropNameInRow="quicach" msprop:Generator_ColumnPropNameInTable="quicachColumn" msprop:Generator_UserColumnName="quicach" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tonkhotoithieu" msprop:Generator_ColumnVarNameInTable="columntonkhotoithieu" msprop:Generator_ColumnPropNameInRow="tonkhotoithieu" msprop:Generator_ColumnPropNameInTable="tonkhotoithieuColumn" msprop:Generator_UserColumnName="tonkhotoithieu" type="xs:decimal" minOccurs="0" />
              <xs:element name="tonkhotoida" msprop:Generator_ColumnVarNameInTable="columntonkhotoida" msprop:Generator_ColumnPropNameInRow="tonkhotoida" msprop:Generator_ColumnPropNameInTable="tonkhotoidaColumn" msprop:Generator_UserColumnName="tonkhotoida" type="xs:decimal" minOccurs="0" />
              <xs:element name="canhbaohandung" msprop:Generator_ColumnVarNameInTable="columncanhbaohandung" msprop:Generator_ColumnPropNameInRow="canhbaohandung" msprop:Generator_ColumnPropNameInTable="canhbaohandungColumn" msprop:Generator_UserColumnName="canhbaohandung" type="xs:int" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tinhtrang" msprop:Generator_ColumnVarNameInTable="columntinhtrang" msprop:Generator_ColumnPropNameInRow="tinhtrang" msprop:Generator_ColumnPropNameInTable="tinhtrangColumn" msprop:Generator_UserColumnName="tinhtrang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cha" />
      <xs:field xpath="mstns:ma" />
    </xs:unique>
    <xs:unique name="DMDoiTuong_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMDoiTuong" />
      <xs:field xpath="mstns:ma" />
    </xs:unique>
    <xs:unique name="Con_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Con" />
      <xs:field xpath="mstns:ma" />
    </xs:unique>
    <xs:unique name="DMHangHoa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DMHangHoa" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Con_Con" msdata:parent="Cha" msdata:child="Con" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="Con" msprop:Generator_ChildPropName="GetConRows" msprop:Generator_UserRelationName="FK_Con_Con" msprop:Generator_ParentPropName="ChaRow" msprop:Generator_RelationVarName="relationFK_Con_Con" msprop:Generator_UserParentTable="Cha" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>